Skip Headers

Oracle® Database Application Developer's Guide - Rules Manager and Expression Filter 10g Release 2 (10.2) Part Number B14288-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# 7 DBMS_RLMGR Package

Rules Manager uses the `DBMS_RLMGR` package, which contains various procedures, to create and manage rules and rule sessions. The following table describes the procedures in the `DBMS_RLMGR` package.

None of the values and names passed to the procedures defined in the DBMS_RLMGR package are case insensitive, unless otherwise mentioned. In order to preserve the case, double quotation marks should be used around the values.

Tip: See the "DBMS_RLMGR" chapter in Oracle Database PL/SQL Packages and Types Reference for all reference information concerning Rules Manager package procedures.

Table 7-1 DBMS_RLMGR Procedures

Procedure | Description
--- | ---
ADD_ELEMENTARY_ATTRIBUTE procedure | Adds the specified attribute to the event structure (and the Expression Filter attribute set)
ADD_EVENT procedure | Adds an event to a rule class in an active session
ADD_FUNCTIONS procedure | Adds a function, a type, or a package to the approved list of functions with an event structure (also the Expression Filter attribute set)
ADD_RULE procedure | Adds a rule to the rule class
CONSUME_EVENT function | Consumes an event using its identifiers and prepares the corresponding rule for action execution
CONSUME_PRIM_EVENTS function | Consumes one or more primitive events with all or none semantics
CREATE_EVENT_STRUCTURE procedure | Creates an event structure
CREATE_RULE_CLASS procedure | Creates a rule class
DELETE_RULE procedure | Deletes a rule from a rule class
DROP_EVENT_STRUCTURE procedure | Drops an event structure
DROP_RULE_CLASS procedure | Drops a rule class
GRANT_PRIVILEGE procedure | Grants a privilege on a rule class to another user
PROCESS_RULES procedure | Processes the rules for a given event
RESET_SESSION procedure | Starts a new rule session within a database session
REVOKE_PRIVILEGE Procedure | Revokes a privilege on a rule class from a user